MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Time & Service Billings (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 102KB | 813 lines

550 1 zer.z-netz.telecom._0130! s417 1 zer.z-netz.telecom.cb-funk! s20 1 zer.z-netz.telecom.datex! s172 1 zer.z-netz.telecom.fax! s1126 1 zer.z-netz.telecom.gateway! s95 1 zer.z-netz.telecom.lan! s24 1 zer.z-netz.telecom.modem! s62 1 zer.z-netz.telecom.satellit! s31 1 zer.z-netz.umweltschutz! s20 1 zer.z-netz.verbrauchertips! s163 1 zer.z-netz.verkehr! s112 1 zer.z-netz.wissenschaft.astronomie! s6 1 zer.z-netz.wissenschaft.biologie! s4 1 z-netz.bildung.allgemein! s15 0 z-netz.b HBAM2016AUG95 Pro 3.0 ni! s68 0 z-netz.datenschutz.allgemein! s125 0 z-netz.datenschutz.spionage! s27 0 z-netz.forum.diskussion.aktuelles! s493 0 z-netz.forum.diskussion.allgemein! s19 0 z-netz.forum.diskussion.philosophie! s24 0 z-netz.forum.diskussion.politik! s2770 0 z-netz.forum.news! s95 0 z-netz.forum.religion! s718 0 z-netz.forum.soziales! s8 0 z-netz.forum.umweltschutz! s102 0 z-netz.forum.verbrauchertip! s67 0 z-netz.forum.verkehr! s108 0 z-netz.forum.versicherung! s32 iere! s284 0 z-netz.freizeit.tv.allgemein! s659 0 z-netz.freizeit.urlaub! s167 0 z-netz.freizeit.video! s285 0 z-netz.freizeit.zeitschriften! s23 0 z-netz.fundgrube.biete! s95 1 z-netz.fundgrube.biete.allgemein! s2043 0 z-netz.fundgrube.biete.elektronik! s2733 0 z-netz.fundgrube.gratis! s206 0 z-netz.fundgrube.job-boerse! s81 0 z-netz.fundgrube.suche.allgemein! s760 0 z-netz.fundgrube.suche.elektronik! s829 0 z-netz.fundgrube.wohnraum! s86 0 z-netz.gesundheit.aids! s4 0 z-netz.gesundheit.allgemein! s104 0 z-netz.gesundheit.drogen! s443 0 HBAM3016AUG95@ Pro 2.0 - 2.1F! Pro 3.0 ACTIVITY AMOUNT CUSTOMER DATE MODIFIED DATE OF START OF WEEK EMPLOYEE HOURS BILLED HOURS WORKED INVOICE ID PROJECT N RECORD ID TOTAL AMOUNT TOTAL HOURS BILLED TOTAL HOURS WORKED A Record IDB DateB Date ModifiedB ActivityB ProjectB RateB Hours BilledB AmountB EmployeeB CustomerB Total Hours BilledB Total Amount Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Description You can use the Time/Service Billings database to track the amount of time worked and billed against a project for a Customer. Specific activity for each project can be designated for detailed record keeping. How to use this solution Each record has both an Hours Worked and an Hours Billed field, because an employee may work unbillable hours (such as during the proposal stage). The employer can run a report to calculate hours worked (for payroll) and hours billed (for accounts $ receivable). How to customize this solution This solution is very expandable, because it contains information about customers, employees, projects, and accounting. You can link to invoices for billing, create reports sorted by activity or by invoice, track employee productivity, and so on. A Form View A List View Date of Start of WeekB 1904) Invoice IDB Hours WorkedB Total Hours WorkedB InfoB A Form ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Hours by Week by Employee Information Report Menu Summary by Customer by Project A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Invoice ID Amount Hours Billed Hours Worked Activity Employee Project Customer Billing Service $Enter data for Time/Service Billings Hours by Week by EmployeeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter AmountZ Hours[ Activity\ Project] Date^ Your Own Button_ Your Own Button` Recorda Delete Recordb Recordc Reportsd View As Liste View As Formf Closeg Infoh*Click to see more information for a record InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Hrs. Billed Hrs. Worked Employee Week of Page ## v0Time/Service Billings; Hours by Week by Employee Your Own Button Reports View As View As Close Hrs. Billed Hrs. Worked Employee Week of Page ## v0Time/Service Billings; Hours by Week by Employee Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO4Information about the Time/Service Billings solutionP Info for this Solution he Time/Service Billings solutionP Info for this Solution Your Own ReportB Your Own ReportC Hours by Week by EmployeeD Summary by Customer by ProjectE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Sort by Date Sort by Project 'Sort for Summary by Customer by Project "Sort for Hours by Week by Employee Summary by Customer by Project Hours by Week by Employee Open Script Sort by Date Summary by Customer by ProjectB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF 06/16/95Y 06/16/95 Prepare Proposal Monthly Newsletter Reynolds Newcomer's Club 6/11/95 06/19/95Y 06/16/95 Initial Draft Monthly Newsletter Smith Newcomer's Club 6/18/95 06/19/95Y 06/16/95 Initial Draft Monthly Newsletter Smith Newcomer's Club 6/18/95 06/22/95Y 06/16/95 Final Draft Monthly Newsletter Smith Newcomer's Club 6/18/95 06/26/95Y 06/16/95 Final Revisions Monthly Newsletter Smith Newcomer's Club 6/25/95 06/30/95Y 06/16/95 Duplication and Distribution Monthly Newsletter Arnold Newcomer's Club 6/25/95 06/19/95Y 06/16/95 Prepare Proposal Brochure Reynolds Newcomer's Club 6/18/95 06/23/95Y 06/16/95 Initial Draft Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Project Amount Hrs. Billed Customer Page ## r5Time/Service Billings; Summary by Customer by Project Your Own Button Reports View As View As Close Project Amount Hrs. Billed Customer Page ## r5Time/Service Billings; Summary by Customer by Project reynolds reynolds evans reynolds smith smith arnold evans smith smith arnold reynolds evans evans Sort by Date Sort by Project 'Sort for Summary by Customer by Project "Sort for Hours by Week by Employee Summary by Customer by Project Hours by Week by Employee Open Script Sort by Date Brochure Evans Newcomer's Club 6/18/95 06/26/95Y 06/16/95 Initial Draft Brochure Evans Newcomer's Club 6/25/95 06/28/95Y 06/16/95 Camera Ready Art Brochure Evans Newcomer's Club 6/25/95 07/01/95Y 06/16/95 Printing and Binding Brochure Arnold Newcomer's Club 6/25/95 Sort by Project Summary by Customer by Project A'Sort for Summary by Customer by Project Hours by Week by Employee A"Sort for Hours by Week by Employee Open Script nsYou did not enter any find criteria; all records will be displayed.C+ ) = 0 Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif Cancel te funct Summary functions Repeating functionsNo records match this request.C+ ) = 1 wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST VDEFA( (LIST VDEFA( (LIST VDEFA( Customer ListB Project ListC Employee List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww )=400 Cancel te funct Summary functions Repeating functionsYou did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel te funct Summary functions Repeating functionsNo records match this request.E+ ) = 1